#region Copyright (c) 2006-2011 Widgetsphere LLC, All Rights Reserved
//--------------------------------------------------------------------- *
//                          Widgetsphere  LLC                           *
//             Copyright (c) 2006-2011 All Rights reserved              *
//                                                                      *
//                                                                      *
//This file and its contents are protected by United States and         *
//International copyright laws.  Unauthorized reproduction and/or       *
//distribution of all or any portion of the code contained herein       *
//is strictly prohibited and will result in severe civil and criminal   *
//penalties.  Any violations of this copyright will be prosecuted       *
//to the fullest extent possible under law.                             *
//                                                                      *
//THE SOURCE CODE CONTAINED HEREIN AND IN RELATED FILES IS PROVIDED     *
//TO THE REGISTERED DEVELOPER FOR THE PURPOSES OF EDUCATION AND         *
//TROUBLESHOOTING. UNDER NO CIRCUMSTANCES MAY ANY PORTION OF THE SOURCE *
//CODE BE DISTRIBUTED, DISCLOSED OR OTHERWISE MADE AVAILABLE TO ANY     *
//THIRD PARTY WITHOUT THE EXPRESS WRITTEN CONSENT OF WIDGETSPHERE LLC   *
//                                                                      *
//UNDER NO CIRCUMSTANCES MAY THE SOURCE CODE BE USED IN WHOLE OR IN     *
//PART, AS THE BASIS FOR CREATING A PRODUCT THAT PROVIDES THE SAME, OR  *
//SUBSTANTIALLY THE SAME, FUNCTIONALITY AS ANY WIDGETSPHERE PRODUCT.    *
//                                                                      *
//THE REGISTERED DEVELOPER ACKNOWLEDGES THAT THIS SOURCE CODE           *
//CONTAINS VALUABLE AND PROPRIETARY TRADE SECRETS OF WIDGETSPHERE,      *
//INC.  THE REGISTERED DEVELOPER AGREES TO EXPEND EVERY EFFORT TO       *
//INSURE ITS CONFIDENTIALITY.                                           *
//                                                                      *
//THE END USER LICENSE AGREEMENT (EULA) ACCOMPANYING THE PRODUCT        *
//PERMITS THE REGISTERED DEVELOPER TO REDISTRIBUTE THE PRODUCT IN       *
//EXECUTABLE FORM ONLY IN SUPPORT OF APPLICATIONS WRITTEN USING         *
//THE PRODUCT.  IT DOES NOT PROVIDE ANY RIGHTS REGARDING THE            *
//SOURCE CODE CONTAINED HEREIN.                                         *
//                                                                      *
//THIS COPYRIGHT NOTICE MAY NOT BE REMOVED FROM THIS FILE.              *
//--------------------------------------------------------------------- *
#endregion

using System;
using System.Linq;
using System.Text;
using Widgetsphere.Generator.Common.GeneratorFramework;
using Widgetsphere.Generator.Common.Util;
using Widgetsphere.Generator.Models;

namespace Widgetsphere.Generator.DAL.ProjectItemGenerators.ActionStoredProcedure
{
	class ActionStoredProcedureGeneratedTemplate : DomainProjectTemplate
	{
		private readonly StringBuilder sb = new StringBuilder();
		private readonly CustomStoredProcedure _currentStoredProcedure;

		public ActionStoredProcedureGeneratedTemplate(ModelRoot model, CustomStoredProcedure currentStoredProcedure)
		{
			_model = model;
			_currentStoredProcedure = currentStoredProcedure;
		}

		#region BaseClassTemplate overrides
		public override string FileName
		{
			get
			{
				return string.Format("{0}.Generated.cs", _currentStoredProcedure.PascalName);
			}
		}

		public string ParentItemName
		{
			get
			{
				return string.Format("{0}.cs", _currentStoredProcedure.PascalName);
			}
		}

		public override string FileContent
		{
			get
			{
				GenerateContent();
				return sb.ToString();
			}
		}
		#endregion

		#region GenerateContent

		private void GenerateContent()
		{
			try
			{
				Widgetsphere.Generator.GenerationHelper.AppendCopyrightInCode(sb, _model);
				this.AppendUsingStatements();
				sb.AppendLine("namespace " + this.GetLocalNamespace() + ".Business.Action");
				sb.AppendLine("{");
				this.AppendClass();
				sb.AppendLine("}");
			}
			catch (Exception ex)
			{
				throw;
			}
		}

		#endregion

		#region namespace / objects

		public void AppendUsingStatements()
		{
			sb.AppendLine("using System;");
			sb.AppendLine("using System.Collections.Generic;");
			sb.AppendLine("using System.Data.SqlClient;");
			sb.AppendLine();
		}

		private void AppendClass()
		{
			try
			{
				sb.AppendLine("	/// <summary>");
				sb.AppendLine("	/// Executes an action based on a stored procedure");
				sb.AppendLine("	/// </summary>");
				sb.AppendLine("	public static partial class " + _currentStoredProcedure.PascalName);
				sb.AppendLine("	{");
				sb.Append("		public static void Execute(");

				var parameters = _currentStoredProcedure.GetParameters().OrderBy(x => x.IsOutputParameter).ThenBy(x => x.Name).ToList();

				int index = 0;
				foreach (var param in parameters)
				{
					sb.Append((param.IsOutputParameter ? "out " : string.Empty) + param.GetCodeType() + " " + param.CamelName);
					if (index < parameters.Count - 1)
						sb.Append(", ");
					index++;
				}

				sb.AppendLine(")");
				sb.AppendLine("		{");
				sb.AppendLine("			using (SqlConnection connection = new SqlConnection(" + GetLocalNamespace() + ".Business.ConfigurationValues.GetInstance().ConnectionString))");
				sb.AppendLine("			{");
				sb.AppendLine("				var command = new SqlCommand(\"[dbo].[gen_" + _currentStoredProcedure.PascalName + "]\", connection);");

				foreach (var param in parameters)
				{
					if (param.IsOutputParameter)
						sb.AppendLine("				command.Parameters.Add(new SqlParameter(\"" + param.PascalName + "\", System.Data.SqlDbType." + param.DataType.ToString() + ") { IsNullable = " + param.AllowNull.ToString().ToLower() + ", Direction = System.Data.ParameterDirection.Output } );");
					else
						sb.AppendLine("				command.Parameters.Add(new SqlParameter(\"" + param.PascalName + "\", " + param.CamelName + "));");
				}

				sb.AppendLine("				command.CommandType = System.Data.CommandType.StoredProcedure;");
				sb.AppendLine("				command.Connection.Open();");
				sb.AppendLine("				command.ExecuteNonQuery();");
				sb.AppendLine();

				index = 0;
				foreach (var param in parameters)
				{
					if (param.IsOutputParameter)
					{
						if (param.AllowNull)
							sb.AppendLine("				if (command.Parameters[" + index + "].Value == System.DBNull.Value) " + param.CamelName + " = null; else " + param.CamelName + " = (" + param.GetCodeType() + ")command.Parameters[" + index + "].Value;");
						else
							sb.AppendLine("				" + param.CamelName + " = (" + param.GetCodeType() + ")command.Parameters[" + index + "].Value;");
					}
					index++;
				}

				sb.AppendLine("			}");
				sb.AppendLine();
				sb.AppendLine("		}");
				sb.AppendLine("	}");
			}
			catch (Exception ex)
			{
				throw;
			}
		}

		#endregion

	}
}